Magenic Waltham , MA 02154
Data & Analytics Professional: Transform Information into Results
Turn data into practical insights that help companies make better business decisions.
Magenic is a business technology consulting firm that unites the power of creative problem-solving with the limitless potential of technology. Every day, our exceptional business technologists create custom tech solutions that help Fortune 1000 companies grow, evolve and succeed.
As a Data & Analytics professional at Magenic, you'll use the latest versions of relational and non-relational platforms to build massive scale enterprise systems. You'll learn industry best practices and approaches to data modeling. You'll extend traditional data warehouse architectures through cloud data services. And you'll use cutting edge data visualization tools to provide compelling reporting every step of the way.
4+ years of Microsoft Database Development / Business Intelligence experience
8+ years development experience on full-life cycle projects
Bachelor's Degree from an accredited college/university
Demonstrated ability to work effectively as part of a team
Demonstrable skills in data modeling, database design, and system architecture with a focus on building secure applications at enterprise scale
Substantial experience with RDMS development, testing and deployment, with a particular focus on SQL Server 2008 R2 - 2016
Expertise with T-SQL and familiarity with SQL variants
Substantial experience with Analysis Services development, testing and deployment, with a particular focus on SQL Server Analysis Services (Tabular) and DAX
Substantial experience with front-end reporting and dashboard development tools, e.g. SSRS, Cognos, Business Objects, MicroStrategy, or other
Working knowledge and/or experience with Power BI (Power BI Online, Power BI Desktop) and related tools
Working knowledge and/or understanding of Azure-based tools and services that support data storage, e.g. Azure SQL, Blob and Table Storage
A strong curiosity about our clients business needs coupled with a passion to stay on the cutting edge of data and analytics tools and techniques
Strong verbal and written communication skills, with a high-level of comfort explaining complex technical topics to business clients
Nice to Have
Experience designing Data Warehouse architecture on the Azure cloud platform
Expertise designing and deploying Data Lake solutions
Architecture of SSAS Cube Reporting Solutions
Able to influence senior management, peers and staff through an inclusive style and recognition of their abilities to achieve results
Demonstrated track record of successful ability to manage large and complex consulting engagements, including a role in managing and interfacing with senior level client executives
Management consulting, advisory, professional services and/or Big 4 consulting experience
Experience with other non-Microsoft data visualization tools, e.g. Tableau, QlikView, Spotfire or other
Working knowledge and/or understanding of Azure-based tools and services that support analysis, mining and reporting, e.g. Analysis Services (PaaS), Azure SQL Data Warehouse, HDInsight, Data Lake Analytics, Stream Analytics, Cognitive Services, etc.
Working knowledge of data services offerings on other Cloud platforms, e.g. Amazon Web Services (AWS), Google, Pivotal Cloud Foundry, etc.
Comprehensive medical/dental/etc. benefits
Health club Reimbursement
Cell phone reimbursement
Annual holiday gifts (GoPro, Xbox, MSFT Surface)
Continuous education & support: Free training/certifications, tech summit, user groups, code camps, tech lunch and learns, Magenic Masters, tuition reimbursement, books, conferences, Yammer, Mentorship/badge program, and more
Plus extras like board game night, company-sponsored happy hours, Fragothons, Friday beer thirty, summer picnic, holiday party, soccer/softball leagues, Magenic In Motion fitness competition, and more