Data Ideology

Title: Data Engineer Location: Remote - USA Full Time Mid Level Job Description: 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. Data Engineer We are looking for a Data Engineer to join our growing team. 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. 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. - Ability to collect and understand business requirements and translate those requirements into an actionable data warehouse plan. - Knowledge of multi-dimensional and tabular design patterns and ability to identify solutions that leverage these modeling techniques. - Ability to work within the SDLC framework in multiple environments and understand the complexities and dependencies of the data warehouse built within those constraints. - Ability to define and implement best practices across database design and ETL. - Ability to direct the work of others, including but not limited to directing ETL development, demonstrating an understanding of key concepts of ETL/ELT, including best practices for optimization and scheduling. Supervisory Responsibilities: None Qualifications Education and Experience: - Proven understanding of Data Warehousing, Data Architecture, and BI. - Experience with data pipelines and architecture/engineering. - Knowledge of modern apps and data platforms. - Cloud-based project implementation. - Python or Java experience is a plus Knowledge, Skills, and Abilities: - BI/Data Warehousing (4+ years) - Cloud platforms (2+ years) - ETL (4+ years) - SQL (4+ years) - Data Modeling - Data Vault Modeling - Healthcare 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:Eligible for Medical, Dental, Vision, 401(k), training and certification reimbursement, and flexible time off in accordance with company policies.

• Partner with business stakeholders, architects, and engineering teams to understand customer needs, business priorities, and technical constraints. • Translate business requirements into actionable user stories, technical requirements, acceptance criteria, and delivery-ready backlog items. • Own and manage the product backlog, ensuring prioritization of the highest-value initiatives aligned with business goals and technical dependencies. • Participate in all phases of the product lifecycle, including discovery, roadmap planning, requirements gathering, development, testing, release, and adoption. • Collaborate with engineering and technical teams to define scalable solution designs, integration requirements, API dependencies, data flows, and system impacts. • Facilitate Agile ceremonies including backlog refinement, sprint planning, stakeholder reviews, and release readiness activities. • Develop KPIs, success metrics, and business analytics to measure product adoption, performance, and ROI. • Continuously gather stakeholder and customer feedback to improve product capabilities and delivery outcomes. • Identify risks, dependencies, and opportunities while helping guide product decisions and delivery execution.

• Design and build scalable, secure, and cost-effective data solutions in Snowflake • Develop and optimize data pipelines using tools such as dbt, Python, CloverDX, and cloud-native services • Participate in discovery sessions with clients to gather requirements and translate them into solution designs and project plans • Collaborate with engagement managers and account teams to help scope work and provide technical input for Statements of Work (SOWs) • Serve as a Snowflake subject matter expert, guiding best practices in performance tuning, cost optimization, access control, and workload management • Lead modernization and migration initiatives to move clients from legacy systems into Snowflake • Integrate Snowflake with BI tools, governance platforms, and AI/ML frameworks • Contribute to internal accelerators, frameworks, and proofs of concept • Mentor junior engineers and support knowledge sharing across the team

• Lead and independently manage the full lifecycle of a data governance engagement • Facilitate stakeholder interviews, workshops, and working sessions to gather requirements and drive decisions • Assess current-state data management practices across systems, files, and spreadsheets • Design and implement data classification frameworks (e.g., Public, Internal, Confidential, Restricted) • Develop actionable data handling guidelines, including access, storage, and sharing standards • Define data lifecycle policies, including retention and deletion practices • Establish data ownership and stewardship models with clear accountability • Identify and remediate data risks such as duplication, inconsistent definitions, and uncontrolled data sharing • Develop and deliver a clear, phased data governance roadmap with prioritized recommendations • Produce high-quality, client-ready deliverables including policies, frameworks, and presentations • Provide guidance and thought leadership to stakeholders throughout the engagement

• Support the design and implementation of strategies that emphasize data ownership, quality, and lifecycle management • Lead AWS platform design (VPC, IAM, networking) and define S3 storage patterns across Bronze, Silver, and Gold medallion layers • Author production-ready Terraform modules with state management and remote backends • Ensure strict tenant isolation across storage and compute layers • Serve as the primary technical authority for all cloud infrastructure decisions • Define and document reference blueprints, CDC/streaming partitioning strategies, operational runbooks, cost-tagging standards, and CloudWatch observability patterns

• Facilitate stakeholder meetings, workshops, and working sessions to gather requirements and support governance initiatives • Assess how data is stored, used, and managed across systems, files, and spreadsheets • Develop and implement data classification frameworks (e.g., Public, Internal, Confidential, Restricted) • Define and document data handling guidelines, including access, storage, and sharing protocols • Contribute to data lifecycle management policies, including retention and deletion standards • Help establish and support data ownership and stewardship roles across the organization • Identify and mitigate common data risks such as duplication, inconsistent definitions, and uncontrolled sharing • Support development and execution of phased data governance roadmaps • Create documentation, policies, and training materials to support adoption • Collaborate with internal teams to ensure consistent and high-quality implementation of governance practices

• Conduct in-depth analysis using the data warehouse to identify trends, patterns, and insights. • Interpret complex data sets and communicate findings to both technical and non-technical stakeholders. • Assist with ETL processes to extract, transform, and load data from various sources. • Collaborate with IT teams to create seamless data integrations. • Perform thorough data validation and testing to ensure the highest possible data quality. • Clearly define and communicate when quality standards are not being met. • Perform root cause analysis to identify the underlying or fundamental causes of an issue or problem. • Work closely with cross-functional teams, including IT and business stakeholders, to align on goals and key deliverables. • Accurately document data mappings and definitions.

• Collect and understand business requirements and translate those requirements into an actionable data warehouse plan. • Knowledge of multi-dimensional and tabular design patterns and ability to identify solutions. • Work within the SDLC framework in multiple environments. • Define and implement best practices across database design and ETL. • Direct ETL development, demonstrating an understanding of key concepts of ETL/ELT.

• Develop, maintain, and enhance production ETL pipelines using Informatica (PowerCenter and/or IICS) • Write, optimize, and troubleshoot complex SQL used for transformations, validations, and analytics • Support and enhance data pipelines loading into Snowflake • Debug failed ETL jobs, data discrepancies, and performance issues across ETL and warehouse layers • Collaborate with business and technical stakeholders to understand data requirements and translate them into working solutions • Support data warehouse environments across cloud and hybrid architectures • Maintain technical documentation, mappings, and workflow logic • Participate in SDLC processes including deployments, testing, and version control