Senior Business Analyst

ICONMA; Englewood (CO); Hybrid; USD 110,000 - 165,000; Full time

Benefits offered by this job

Health Benefits

Referral Program

Excellent growth and advancement opp.

Job summary

ICONMA is seeking a Senior Business Analyst in Englewood, CO with hybrid work options. The role focuses on transforming complex business processes into scalable data solutions, leveraging SQL, data modeling, ETL, and Spark to deliver timely analytics and dashboards.

Ideal candidates will have 10+ years of experience in data-driven environments, strong communication skills, and relevant certifications such as CBAP or Azure Data Engineer Associate.

Qualifications

• 10+ years of experience as a business analyst in data-focused environments.
• Strong SQL, data modeling, and ETL development expertise.
• Hands-on experience with Spark and NoSQL data stores.
• Excellent communication to translate business needs into data solutions.
• Certifications CBAP or data-specific credentials preferred.

Responsibilities

• Analyze complex processes and data flows to define detailed data requirements.
• Translate requirements into logical and physical data models for scalable solutions.
• Collaborate with infra and app teams for stable data environments.
• Design relational and non-relational schemas for reporting and analytics.
• Develop and optimize SQL queries and stored logic for dashboards.
• Apply NoSQL modeling for large-scale semi-structured data.
• Define and validate ETL workflows aligned with data models.
• Utilize Spark for batch and near real-time pipelines delivering insights.
• Document data dictionaries source-to-target mappings for dev/testing.
• Support data validation, troubleshooting, and user adoption.
• Contribute to standardization of practices to raise data maturity.

Skills

Advanced SQL

Data modeling

ETL development

Spark processing

NoSQL databases

Analytical thinking

Education

CBAP certification

Microsoft Azure Data Engineer Associate

Bachelor's degree

Tools

Spark

ETL tools

SQL Server

Job description

Our Client, an IT Services and Consultant company, is looking for a Senior Business Analyst for their Englewood, CO/Denver CO/Hybrid location.

Responsibilities:

• Analyze complex business processes and data flows to define detailed requirements that guide the design of scalable data solutions aligned with enterprise objectives and regulatory expectations.
• Translate business requirements into logical and physical data models that optimize performance, maintainability and consistency across transactional and analytical systems.
• Coordinate end to end database installation activities by collaborating with infrastructure and application teams to ensure stable environments and reliable data availability for business operations.
• Design and refine relational and nonrelational database schemas that support reporting, analytics and integration needs while maintaining data quality and integrity.
• Develop and optimize SQL queries, views and stored logic to support dashboards, operational reports and ad hoc analysis with a strong focus on performance and accuracy.
• Apply No SQL data modeling practices to support large scale semi structured or unstructured data workloads and ensure optimal access patterns for analytics and downstream consumption.
• Define and validate ETL workflows by working with engineering teams to ensure data extraction transformation and loading steps are robust, reusable and aligned with target data models.
• Use Spark based data processing techniques to support batch and near real time data pipelines that deliver timely insights to business stakeholders and downstream applications.
• Document detailed functional specifications data dictionaries and source to target mappings that provide clear guidance for development testing and operations teams. Collaborate with cross functional stakeholders to prioritize analytic features enhancements and defect resolutions that improve data reliability and decision support capabilities.
• Conduct data validation and reconciliation activities to identify defects anomalies and root causes and recommend corrective actions that protect analytical accuracy and trust.
• Provide ongoing support to business users by clarifying data definitions troubleshooting data pipeline issues and recommending enhancements that improve usability and adoption.
• Contribute to continuous improvement initiatives by recommending standardization of database design practices ETL patterns and metric definitions that strengthen organizational data maturity.

Requirements:

• Demonstrate advanced knowledge of relational databases including design normalization indexing and query optimization supported by several years of practical project experience.
• Show strong experience in database installation configuration and environment validation across development testing and production instances for enterprise scale systems.
• Apply solid SQL expertise including complex joins window functions and aggregation logic to support analytical reporting and operational workloads in high volume settings.
• Exhibit practical No SQL experience using document key value or column oriented data stores with clear understanding of appropriate use cases and modeling strategies.
• Display hands on ETL experience across design testing and deployment using enterprise tools or frameworks while maintaining robust error handling and data validation practices.
• Utilize Spark for data transformation and aggregation across large datasets with clear focus on performance tuning resource optimization and reliable pipeline execution.
• Leverage analytical and communication skills gained through six to ten years of professional experience as a business analyst in data driven or technology focused organizations.
• Certifications Required : Preferred certifications include CBAP and one data focused credential such as Microsoft Azure Data Engineer Associate or equivalent.
• Years of Experience: 10.00 Years of Experience

Why Should You Apply?

• Health Benefits
• Referral Program
• Excellent growth and advancement opportunities