Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Data Lake Architect - Boston

Expired Job

Magenic Waltham , MA 02154

Posted 5 months ago

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.

The Requirements

  • 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.

  • Experience with custom application development using .NET, Java, JavaScript and/or related technologies and frameworks


  • Comprehensive medical/dental/etc. benefits

  • Revenue sharing/401k

  • Paid holidays

  • Generous PTO

  • Health club Reimbursement

  • Cell phone reimbursement

  • Powerful laptop

  • 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

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Oracle Database Architect/ Data Architect

Collabera Inc

Posted 2 days ago

VIEW JOBS 10/17/2018 12:00:00 AM 2019-01-15T00:00 Position Summary: Financial Services client seeks a Senior DBA/Data Architect with 10+ years of experience to provide hands-on expertise to the Financial Crime Control (FCC) products development team. FCC is a market leader in providing regulatory compliance and financial crime solutions for financial services market. Essential responsibilities require the candidate to work with Technical Leads, Architects and other stakeholders to specify design and implement business solutions, to work with Technical Support group to formulate solutions to critical issues and to collaborate with off-shore team to deliver quality results. Experience and Skills: BA/BS in Technology area (i.e. Computer Science) or related field or equivalent work related experience. 10+ years experience in software product development with progressive increases in leadership roles/ responsibilities. Experience with various data modeling techniques and processes. Have the ability to understand business requirements and create data models that address these needs. Database designing, database performance, manaLeading Healthcarement and tuning experience. Development experience with Oracle database 10g & 11g Experience in database programming (Stored Procedures, trigLeading Healthcarers, batch jobs, SQL loader etc). Experience in query optimization and database tuning Experience in handling larLeading Healthcare data volume (hundreds of gigabytes) Experience in the support and development of web based applications. Track record of delivering quality software on time in collaboration with others. MS SQL Server experiences a plus. Experience in Data Analysis and good knowledLeading Healthcare in data Migrations tools. KnowledLeading Healthcare in Data Modeling, Data Integration, Database Design is a must Experience with Oracle RAC, Data Guard Clear understanding of SAN, NAS, Mirroring, striping and other related data storaLeading Healthcare concepts Experience with sizing hardware/storaLeading Healthcare for given data processing and growth needs Additional Job Details: Familiarity with application architectures in a distributed computing environment. Data Warehousing knowledLeading Healthcare is plus Experience with Agile process Insurance, financial industry experience is a plus. Business Modeling using Use Cases; UML modeling tools is a plus. Other KnowledLeading Healthcare, Skills, Abilities, Certifications: The ability to work with a variety of technical resources that are both Financial services employees and part of an outsourced development arranLeading Healthcarement. The ability to work cross-functionally and with many service providers and business partners. Strong communication skills (both verbal and written) effective in a variety of informal and formal settings. Strong analytical and team-based problem solving skills. Ability to multi-task and to switch context effectively Strong client focus dedicated to meeting the expectations and requirements of internal and external clients, acts with client in mind, and establishes and maintains effective working relationships with clients. Strong learning, reasoning, negotiating and problem solving ability. Strong decision making skills can make quality decisions in a timely manner. Strong negotiation and conflict manaLeading Healthcarement skills can find common ground and Leading Healthcaret cooperation with minimum noise. Ability to display endurance and capacity for a fast paced work environment. Strong business acumen knows how businesses work, and knowledLeading Healthcareable in current and possible future practices, trends, and developments affecting his/her business and organization. Maintains functional and technical knowledLeading Healthcare and skills to perform the job at a high level of accomplishment. Oracle certification preferred. Essential Duties and Responsibilities: Translate high level requirements into detailed designs, negotiating with product manaLeading Healthcarement, as needed. Code complex database programs (stored procedures, scripts etc.) and derive logical processes. Participate in the analysis, design, development, troubleshooting, debugging and maintenance of database functionality of a complex Software-as-a-Service (SAAS) application. Responsible for formulating and implementing the team's technical data vision, providing hands-on insight into system architecture, data software development and data modeling. Establishes database manaLeading Healthcarement systems, standards, guidelines and quality assurance for database deliverables, such as conceptual design, logical data model capacity planning, external data interface specifications, data loading, data maintenance plan and security policies. Collaborates with developers and facilitates interaction between production DBAs and developers. Determines appropriateness of data storaLeading Healthcare, archive, purLeading Healthcare and backup strategies. Capable of working proficiently at both strategic and tactical aspects of a project. KnowledLeading Healthcare of current industry database standards such as Web Services, Object Oriented Development, Collaborative development techniques, especially in a Java development environment. Capable of communicating effectively in both verbal and written form. Quickly understand the data structures of multiple systems Identify integration issues from their understanding of the systems architectures Design batch and messaging interfaces between the systems Client: Leading Publishing and Media client Location: Waltham MA Duration: 3 Months contract to coversion FTE Contact Details: Nikunj Patel Collabera Inc. 973-774-1097 Collabera Inc Waltham MA

Data Lake Architect - Boston

Expired Job