Senior Data Engineer/Cloud Data Architect (Consulting)

About Us SolomonEdwardsGroup, LLC (“SolomonEdwards”) is a full-service professional services firm offering financial, operational, and technology consulting and operations support. We work with some of the world’s most prominent companies to help them envision and achieve a better future. We know that our consulting services are only as meaningful as the people and talent behind them, and we are committed to recruiting incredibly talented, committed, and collaborative individuals who can help us deliver exceptional client service. For more information, visit SolomonEdwards Position Summary: We are seeking a highly skilled Senior Data Engineer / Cloud Data Architect to support a major enterprise data modernization initiative. This role will focus on architecting, building, and optimizing a modern cloud-native Enterprise Data Warehouse (EDW) environment from the ground up. The ideal candidate will possess deep expertise in enterprise data engineering, advanced SQL development, cloud-native architectures, ETL/ELT frameworks, API integrations, and large-scale enterprise data transformations. This is a highly technical, hands-on role supporting complex enterprise analytics, ingestion, and cloud data platform initiatives. Essential Duties: • Architect enterprise-scale cloud-native data warehouse solution. • Design scalable ETL/ELT pipelines across enterprise platforms. • Develop advanced SQL transformations and enterprise data models. • Lead API-based enterprise data ingestion initiatives. • Support synchronization across ERP, CRM, analytics, and operational systems. • Optimize cloud platform scalability, reliability, and performance. • Troubleshoot complex enterprise data issues and perform root cause analysis. Qualifications: • Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field. • 7+ years of Data Engineering, Data Architecture, or Enterprise Analytics experience. • Extensive experience building Enterprise Data Warehouses (EDW) from the ground up. • Strong experience working within cloud-native enterprise environments. • Experience supporting enterprise modernization and cloud migration initiatives preferred. • Industry experience within healthcare, financial services, or insurance environments preferred. Skills and Job-Specific Competencies: • Expert-level SQL development, including complex queries, CTEs, window functions, stored procedures, and query optimization. • Strong hands-on experience with Google BigQuery, Databricks, and Microsoft Fabric. • Experience with API integrations and enterprise data ingestion frameworks. • Experience with enterprise ETL/ELT tools and cloud data pipelines. • Knowledge of cloud-native data platforms and EDW architecture. • Experience with data lakes, Lakehouse concepts, and enterprise data modeling. • Familiarity with Star and Snowflake schema design. • Experience with Azure Data Factory (ADF), Power BI, Tableau, or Looker preferred. • Strong analytical and problem-solving abilities. • Excellent communication and cross-functional collaboration skills. • Ability to manage multiple priorities in fast-paced environments. • Strong documentation and organizational skills. Travel Requirements: No travel will be required, unless at the client's discretion. Physical Requirements: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be provided to qualified applicants or candidates with disabilities upon request to enable them to perform essential functions. This role may require mobility to attend in-person meetings, sitting or standing for extended periods, and the use of telephone, computer, or other electronic communication devices. Salary Range: SolomonEdwards values your unique and individual experience and background. As such, we take a comprehensive approach when determining compensation for our roles. The compensation for this specific role is based on a wide range of factors, including but not limited to education, licensure and certifications, location, experience, and training. A reasonable estimate for the current hourly range for this role is $95 – 110. Benefits: We are committed to providing health and financial stability by offering a comprehensive suite of benefits. Benefits include access to top-tier employers and job opportunities, health insurance, sick leave, and 401(k). Inclusion and Diversity Statement: SolomonEdwards is an Equal Opportunity/Affirmative Action employer. We firmly believe in fostering an inclusive and diverse workplace environment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, gender identity, sexual orientation, veteran status, or any other characteristic protected by applicable laws. All employees, including managers and supervisors, are responsible for upholding our EEO and diversity principles. Discrimination or harassment of any kind will not be tolerated. We value the contribution and wisdom of the team. At SolomonEdwards, we have built a vibrant and inclusive community. Our team members are curious, committed, and diverse. In keeping with our mission to build value through people, we cultivate a culture where differences are celebrated, and all members are treated fairly and equitably. Employees, business partners, and our extended stakeholder family are empowered to share their experiences, ideas, and perspectives and to be their whole selves. Privacy: We adhere to the California Consumer Privacy Act (CCPA). Your privacy is important to us, and we never sell your data to third parties. Personal information is only collected to match applicants with job opportunities. Copy/paste this URL to learn more about your rights: SolomonEdwards' Privacy Policy. Our Recruiter Promise: Our talent acquisition team prioritizes integrity, professionalism, and transparency in every interaction. When you engage with SolomonEdwards, you can trust a respectful, secure experience from verified contacts. Copy/paste this URL to learn more about how we protect your candidate experience: Recruiter Promise.