2 jobs found

Job Description Job Description Pay Rate Range: $ 46.96 - 50.75/hr. Job Description: Key Responsibilities: •Work with business/data product team to translate given business problem into analytical solution with defined outcomes. •Analyze the data in depth, informatica MFT, using SQLs and other exploratory tools against various platforms such as Bigdata, Oracle, SQL Server and others. •Convert business requirements to functional requirements, with detailed transformation rules for ETL team. This is a very technical hands-on role and mandatory to have Informatica MFT, DBT and snowflake •Work closely with the ETL and data science teams to review the requirements and data integrations. •Understand the requirements from Business and Data Science. Understand the business and business impact on use cases. •Write validation scripts to validate the data loaded by ETL team an assess using MFT / DBT. •Work with IT and business customers to develop and design requirements to formulate technical design. •Skills to understand the right functional domain knowledge of the business to be able to gather right requirements for the design. •Capture meta data, data lineage, reference data management and data quality rules as part of data governance. •Work with team spread across the globe in driving the delivery of projects. Required Skills/Knowledge: •Bachelor's degree in computer science, Engineering, or related discipline. •8 years of solutions development / analysis experience, including 5 years in data management/engineering organization. •Proficient understanding of distributed computing principles and informatica Scripts / MFT •Extensive experience in data analysis and data modeling (table design). •Proficiency in SQLs and data exploratory tools. •Extensive experience writing functional requirements and high-level design documents. •Experience in writing validation scripts to validate the data, data integrations and ETL transformations. •Analytical skills to analyze situations and come to optimal and efficient solution based on requirements. •Strong data analysis and profiling skills. •Data warehouse concepts. •Strong analytical skills related to working with unstructured datasets. •SQL knowledge and data analysis skills for data anomaly detection and data quality assurance. •Excellent communication skills, both written and verbal Preferred: •Experience working on MFT and DBT skills and should posses cloud knowledge. •Strong background or working experience in Insurance Industry as a Lead analyst. •Ability to interact with senior leadership teams in IT and business raise the required defect and track project end to using manual or automation design creation. •Should have good SQL knowledge/ AWS and snowflake. •Should be good in Agile methodologies and SDLC process. Skills:CategoryNameRequiredImportanceExperienceSkillCategoryTest1_MNDigital : SnowflakeYes1>7 years

Job Description Job Description Senior Data & Analytics ArchitectEnterprise Data Warehouse Modernization Remote 12+ Month Contract Candidates must be authorized to work in the United States without sponsorship. Not open to third-party firms, consulting companies We are seeking a Senior Data & Analytics Architect to lead a large-scale Enterprise Data Warehouse (EDW), reporting, and analytics modernization initiative. This is a hands-on architecture leadership role responsible for defining technical strategy, solution architecture, modernization roadmaps, and engineering execution across enterprise data, reporting, and analytics platforms. Key Responsibilities Lead end-to-end architecture for enterprise data warehouse, reporting, analytics, and data integration solutions. Drive modernization of legacy ETL processes, SQL code, Unix/Linux scripts, and manual workflows into scalable Python-based solutions and automation frameworks. Translate complex business, operational, and regulatory requirements into scalable and maintainable technical designs. Design architecture across databases, APIs, application services, orchestration, scheduling, security, monitoring, and cloud platforms. Build proof-of-concepts and evaluate technology options to support architectural decision-making. Lead enterprise reporting and analytics initiatives, including data quality, reconciliation, drill-down reporting, and reporting modernization. Establish engineering best practices utilizing Azure DevOps, CI/CD pipelines, source control, code review processes, and deployment automation. Partner with infrastructure, cloud, security, analytics, and engineering teams to deliver enterprise-scale solutions. Develop architecture diagrams, technical specifications, implementation plans, operational models, and modernization roadmaps. Mentor architects, engineers, ETL developers, BI developers, analysts, and testers. Present technical recommendations, risks, and strategic solutions to executive leadership and key stakeholders. Required Qualifications Bachelor's degree in Computer Science, Engineering, Information Systems, or a related discipline, or equivalent professional experience. 10+ years of experience in Data Architecture, Analytics Architecture, Solution Architecture, or Enterprise Architecture roles. Proven success architecting and delivering enterprise data warehouse, analytics, reporting, and transaction-processing solutions. Strong hands-on Python development experience. Advanced SQL development, optimization, and troubleshooting expertise. Experience designing data-intensive applications, APIs, databases, security frameworks, job scheduling, and monitoring solutions. Experience with enterprise BI and reporting tools such as Power BI, Tableau, BusinessObjects, SAS, or similar platforms. Experience implementing Azure DevOps, Git-based source control, branching strategies, CI/CD pipelines, and automated deployment processes. Experience leading cross-functional engineering and analytics teams. Excellent communication and stakeholder management skills. Preferred Qualifications Healthcare payer, Medicaid, managed care, or health insurance experience. Experience supporting CMS, Medicaid, regulatory, or federal reporting initiatives. Experience with cloud migration and modernization programs. Hands-on experience with Azure, Azure Data Factory, Databricks, Azure Data Lake Storage, Snowflake, or similar cloud data platforms. Experience with Informatica, Teradata, or enterprise ETL and data integration technologies. Strong data modeling experience, including conceptual, logical, physical, dimensional, and transactional models. Experience leveraging AI-assisted engineering, automation, testing, or code conversion within enterprise environments. Knowledge of HIPAA, PHI, PII, and regulated data environments. Preferred Technical Stack Python SQL Azure Azure Data Factory (ADF) Databricks Snowflake Teradata Informatica Power BI Tableau BusinessObjects Azure DevOps CI/CD Data Warehousing Analytics Data Integration Enterprise Architecture Additional Requirements 12+ month contract opportunity. 100% remote position. Candidates must reside within the Continental United States. Candidates must be authorized to work in the United States without sponsorship. Not open to third-party firms, consulting companies, C2C arrangements, or vendor submissions. Direct applicants only. Why Join Us Lead enterprise-scale data and analytics modernization initiatives. Influence architecture strategy and technology direction. Work with modern cloud and data platforms. Drive transformation from legacy technologies to scalable, automated solutions. Collaborate with senior leadership and high-performing technical teams.