Senior Data Engineer

Senior Data EngineerConsumer Cellular is seeking skilled Senior Data Engineers who thrive in a highly collaborative, agile team environment. Engineers at Consumer Cellular design elegant technical solutions for complex product requirements, deliver high quality code as part of a fast-moving agile team, and own the stability and quality of their domain. We would love to hear from talented engineers who share our passion for leveraging the latest technology to provide a best-in-class experience to our customers.You will need to reside within 50 miles of our Corporate Headquarters in Scottsdale, AZ as this role has the option of hybrid or onsite.ResponsibilitiesCollaborate with data engineering and cross-functional teams to build and deliver custom enterprise data warehousing and database solutions.Accurately estimate tasks, bugs, and spikes in your domain.Develop software that meets code quality standards and metrics.Build productive internal/external working relationships.Effectively manage risk, change, and uncertainty with support from your leader and peers.Build a solid understanding of inter-team functional data dependencies and navigate appropriate communication channels for solving issues as they arise.Design and implement new features while continuously improving quality of technical data products and database applications.Act as a technical expert and engineer on an agile squad.Create and execute long term vision of technical data products and database applications.Drive the architectural solutions across data warehousing and transactional databases.Develop and Lead communities of practice by mentoring engineers, creating, and enforcing standards, reviewing others code, and sharing knowledge and know-hows.Remain current on new cloud data solutions, design patterns, products, and development trends.Assist with problem resolution for customers and end users.Other duties, as maybe assigned.Skills and ExperienceExpert knowledge of data engineering, database solution design, solid principles of data modeling.Experience 5 years in data engineering and database technologiesExperience in developing reusable common component data artifacts.Experience with Data Engineering and Cloud productsExperience in various Data Engineering Methodologies and Data Warehousing ModelsExperience in data governance and security best practicesExperience in data accessibility best practicesStrong problem solving and collaboration skillsExcellent verbal and written communication skillsStrong Team Player and a CoachBachelor's degree in Computer Science/Information Systems or comparableTechnology RequirementsRequired:Experience in SQL, Python and Enterprise Data WarehousingProficient in Azure or similar cloud technologies – Data Factory, Data Lake, Function App.Experience in building out ELT (Extract Load Transform) solutionsExperience in SQL Server, Spark, Azure Synapse, Kafka or similarProficient in writing SQL Queries and Python NotebooksPreferred:Knowledge of one or more modern database data models, design and Reporting Data frameworks representative of ELT, ETL or similarGit HUB – Enterprise or similarOther Cloud Technologies for Data Engineering – Snowflake, Databricks, FabricPhysical Demands & Work EnvironmentThe physical demands and work environment 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 made to enable individuals with disabilities to perform the essential functions.While performing the duties of this Job, the employee is regularly required to sit, stand, and walk. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus.The noise level in the work environment is usually moderate.Pay & Benefits Data+ Minimum Salary: $113,000+ Maximum Salary: $161,700This information reflects the anticipated base salary range for this position based on current national data. Minimums and maximums may vary based on location. Individual pay is based on skills, experience and other relevant factors. Our Talent Acquisition team are able to answer any additional questions you may have as you move through the selection process. As part of our Total Rewards package, Consumer Cellular, Inc. offers a broad range of Health, Life, Voluntary Lifestyle and other benefits and perks that enhance your physical, mental, and emotional wellbeing.+ Competitive base pay with potential for shift differential, overtime and bonus pay+ Medical insurance (98% company-paid for full-time employee only coverage)+ Dental and Vision insurance (100% company-paid for full-time employee only coverage)+ 401(k) company match of 100% up to 6% of your pay+ Discounted Consumer Cellular wireless phone plan for employees+ Paid Time Off ( PTO ) available following a 30-day waiting period+ 6 company-paid holidays plus 16 hours of floating holiday accrual per year+ Flexible Spending Accounts ( FSA ) for health care and dependent care expenses+ Life and AD&D insurance equal to 1x your annual earnings (100% company-paid)+ Long-Term Disability insurance (100% company-paid)+ Employee Assistance Program (100% company-paid)