Sr. Data Business Analyst – SQL / Spark / ETL / NoSQL

Iconma

Englewood, CO
9 days ago

$15–$53.57 Per Hour

Highlights

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. 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.

Numbers & Facts

Location	Englewood, CO
Industry	Management Consulting Services
Salary	$15–$53.57 Per Hour
Company Size	2,000 to 2,499 employees
Year Founded	2000
Website	https://www.iconma.com/

Description

Our Client, an IT Services and Consultant company, is looking for a Sr. Data Business Analyst – SQL / Spark / ETL / NoSQL 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.
60CW00 Business Associate
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

Benefits

401K, Employee Referral Program, Life Insurance

About Company

ICONMA is a global information consulting management firm providing Professional Staffing Services and Project-Based Solutions for organizations in a broad range of industries.

Corporate Headquarters in Troy, Michigan; 20+ locations worldwide.
Certified Woman-Owned Business Enterprise (WBE); certified by Women’s Business Enterprise National Council, National Women Business Owners Corporation (NWBOC); and California Public Utilities Commission (CPUC).
Founded in 2000
2000+ Employees

The company was founded on the principle that success is derived from delivering high quality service and resources in the most responsive, flexible, and innovative way. ICONMA invests in people and resources with a single goal: To provide our customers with the highest quality service in the most responsive manner. Through its network of offices, ICONMA provides the resources to help clients maintain their competitive advantage.