Company Description
Zayo provides mission-critical bandwidth to the world's most impactful companies, fueling the innovations that are transforming our society. Zayo's 141,000-mile network in North America and Europe includes extensive metro connectivity to thousands of buildings and data centers. Zayo's communications infrastructure solutions include dark fiber, private data networks, wavelengths, Ethernet, and dedicated Internet access. Zayo serves wireless and wireline carriers, media, tech, content, finance, healthcare and other large enterprises.
Zayo provides mission-critical bandwidth to the world's most impactful companies, fueling the innovations that are transforming our society. Zayo's 141,000-mile network in North America and Europe includes extensive metro connectivity to thousands of buildings and data centers. Zayo's communications infrastructure solutions include dark fiber, private data networks, wavelengths, Ethernet, and dedicated Internet access. Zayo serves wireless and wireline carriers, media, tech, content, finance, healthcare and other large enterprises.
Position Description
The Data Modeler role encompasses designing, implementing, and maintaining data models across Snowflake, Azure or AWS environments. Responsibilities include collaborating with stakeholders to translate business requirements into effective data models, optimizing database performance, and ensuring compliance with data governance standards. Data Modelers play a crucial role in maintaining the medallion architecture, facilitating seamless data integration and interoperability within cloud environments while staying abreast of technology advancements to continuously enhance data modeling practices. The ideal candidate possesses strong analytical skills, proficiency in data modeling tools, and expertise in Snowflake, Azure or AWS database management systems.
Responsibilities:
1. Data Modeling:
Design, develop, and maintain conceptual, logical, and physical data models that accurately represent the organization's data assets.
Collaborate with stakeholders to understand business requirements and translate them into data models that support data-driven decision-making and business objectives.
Implement best practices for data modeling, including normalization, denormalization, and optimization techniques to ensure data integrity and efficiency.
Design a historical aggregation strategy to optimize data retention
2. Database Design and Optimization:
Work closely with database administrators and developers to implement data models into database systems efficiently, including Snowflake, Azure, and AWS.
Perform database performance tuning and optimization to enhance system performance and scalability in cloud environments.
Partner with data engineering teams to define allowable table structures, naming conventions, and schema design.
Conduct regular reviews and updates to data models to accommodate changes in business requirements and technology advancements in Snowflake, Azure, and AWS ecosystems.
3. Data Governance and Compliance:
Ensure data models comply with data governance policies, standards, and regulations.
Collaborate with data governance teams to establish data modeling standards, processes, and procedures.
Strategy to manage data models, key capabilities and tooling recommendations
Participate in data governance initiatives to improve data quality, consistency, and security across platforms.
4. Data Integration and Interoperability:
Develop data integration strategies and solutions to enable seamless data flow between systems and applications.
Integration with new and existing data governance and data design applications
Ensure data models facilitate interoperability and data exchange across disparate systems and platforms.
Collaborate with integration architects and developers to implement data integration solutions effectively.
Qualifications:
Bachelor's or Master in Computer Science, Information Systems, or a related field.
7+ years proven experience in data modeling, database design, and database management systems, with expertise in Snowflake and AWS environments.
Strong understanding of data engineering, data modeling concepts and techniques, including relational, dimensional, and NoSQL data models.
Proficiency in data modeling tools such as ERwin, ER/Studio, or PowerDesigner.
Experience with database management systems such as Snowflake, Azure, and AWS.
Excellent analytical, problem-solving, and communication skills.
Certification in relevant areas such as Azure, Snowflake, or cloud computing is desirable.
Benefits, Rewards & Wellness
Excellent Health, Dental & Vision Insurance
Retirement 401(k) Savings Plan
Generous paid time off policy including paid parental leave
Zayo provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, provincial or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
Base pay range: $136,900 - $160,000, commensurate with experience.
Benefits, Rewards & Wellness
Excellent Health, Dental & Vision Insurance
Retirement 401(k) Savings Plan
Fitness membership discounts
Generous paid time off policy including paid parental leave
Zayo provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, provincial or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.