Senior Business Analyst at ICONMA in Englewood, CO

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

Skills

Required

• Database installation and configuration
• SQL expertise
• NoSQL experience
• ETL experience
• Spark
• Analytical and communication skills

Preferred

• CBAP certification

Benefits

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