Data Ideology

At DI, we provide Data & Analytics expertise to drive measurable business outcomes, often solving complex business problems for our clients. Our data analytics advisory services enable our customers to transform data into insights by driving a culture of empowerment and ownership of results. Our team consists of highly motivated individuals passionate about learning, understanding, collaborating, and intellectually curious.  For more information about Data Ideology, visit www.dataideology.com

Senior Data Engineer - Full-time

We are looking for a Sr. Data Engineer to join our growing team. Sr. Data Engineer will leverage their business and technical knowledge to develop production-ready data models by integrating multiple data sources while working with business and technical teams to understand business strategy and objectives, gather information, and ensure business requirements are being fulfilled throughout the entire data & analytics lifecycle.

Key Responsibilities

To perform in this position successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions. Other duties may be assigned to meet business needs.

Design, build, and optimize ETL/ELT workflows using SSIS for various data integration needs

Develop and maintain T-SQL scripts, stored procedures, and functions within SQL Server to support data movement and transformation

Collaborate with data architects and analysts to design and implement data warehouse solutions using dimensional modeling best practices

Support and enhance data solutions aligned with the medallion architecture (bronze, silver, gold layer concepts)

Monitor, troubleshoot, and optimize performance of SSIS packages and SQL queries

Ability to collect and understand business requirements and translate those requirements into an actionable data warehouse plan.

Ability to work within the SDLC framework in multiple environments and understand the complexities and dependencies of the data warehouse built within those constraints.

Supervisory Responsibilities: None

Qualifications

Education and Experience:

5+ years of professional experience in a Data Engineering or ETL Developer role

Hands-on experience developing and deploying SSIS packages

Proven experience working in a data warehouse environment, particularly with dimensional modeling (star/snowflake schemas)

Familiarity with data pipeline design aligned to medallion architecture or similar layered data lake approaches

Knowledge of data governance, data quality, and data cataloging practices

API integration experience is a plus

Knowledge, Skills, and Abilities:

BI/Data Warehousing (5+ years)

Ability to work independently and collaboratively in a fast-paced environment

Strong analytical, troubleshooting, and communication skills

Banking experience a plus

Consulting experience a plus

Work Environment:

Remote work from home.

Hours of work and days are generally Monday through Friday. Specific business hours will depend on client needs.

Physical Demands:

Must be able to remain in a stationary position 50% of the time.

The person in this position must occasionally move about inside the office to access file cabinets, library stacks, office machinery, etc.

Constantly operates a computer and other office productivity machinery, such as a calculator, copy machine, and printer.

The person in this position frequently communicates with clients and coworkers. Must be able to exchange accurate information in these situations.

Benefits:

Flexible Time Off Policy

Eligibility for Health Benefits

Retirement Plan with Company Match

Training and Certification Reimbursement

Utilization Based Incentive Program

Commission Incentive Program

Referral Bonuses

Work from Home

Data Ideology is an EEO Employer

Powered by JazzHR

xQH6ZRD1Ld