Junior BI Developer at American Marketing Association

The Jr. BI Developer’s initial primary responsibility is to support delivery, progressing to delivery of user-friendly, trustworthy, and relevant collections of data for use in analysis, exploration, and the development of dashboards.

What You Have

• Bachelor’s degree or equivalent work experience
• Two (2) years of ETL development experience with a preference of 1-year hands-on experience with enterprise analytics tool set (Sigma preferred).
• Two (2) years of hands-on experience with the databases such as AWS, Snowflake, Oracle, SQL Server, DB2 etc.
• Proficiency in data quality development around address validation services, data profiling, cleansing, parsing, standardization, verification, matching and data quality exception monitoring and handling
• Excellent data analysis and data profiling skills.
• Strong experience on data quality development process, issue management, and data remediation
• Experience with and understanding of unit testing, release procedures, coding design and documentation protocol as well as change management procedures
• Expertise with integration technologies and processes

What You May Also Have

• AWS Certifications
• Sigma, Tableau, PowerBI experience
• Wordpress or Salesforce experience
• Consulting or implementation provider project experience for large-scale CRM, CMS, DW deployments
• Experience with ETL development using API’s

Description

To support and accelerate AMA’s strategic initiatives for data warehousing, analytics, and data democratization by developing data models that combine data from multiple sources and apply data cleaning, standardization, and transformation approaches in keeping with the AMA Data Team’s established practices. The Jr. BI Developer’s initial primary responsibility is to support delivery, progressing to delivery of user-friendly, trustworthy, and relevant collections of data for use in analysis, exploration, and the development of dashboards.

Essential Job Function

• Working with BI Developer, design and develop dashboards and reports in Sigma, to support company’s BI needs
• Maintain and update existing dashboards and reports.
• Cleans and manages data, in addition to migrating and integrating data with various sources.
• Collaborate in the implementation of developing models, productionizing code, and incorporating the results of such models into the BI environment.
• Contribute to the AMA Data Warehouse codebase and collaborate in the release management, documentation and maintenance thereof, including refactoring and query optimization.
• Participate in Scrum activities and share ownership of the commitments of the Data Team, including operational and administrative tasks when the need arises, such as incident identification, investigation, and resolution for components of the data platform such as AWS, Fivetran, dbt and Sigma.

What You’ll Get

• You’ll get daily hands on experience working in a fast-paced environment, on numerous projects in AWS, Sigma, ETL tools, comprised of numerous integrations, applications and plug-ins
• A true ability to have an impact in delivering technology change in an ideal digital transformation period for the organization
• Free American Marketing Association membership
• Ability to attend professional development programs offered through the AMA
• Remote work-life balance with flex Fridays, unlimited sick leave, two weeks of parental bonding leave, paid vacation leave, generous paid holiday schedule, and SIX days of paid volunteer time off per year.

Comprehensive benefit package that includes your choice of two medical plans with Blue Cross Blue Shield, your choice of two dental plans and a vision plan with Guardian. We also offer a retirement plan with an employer match and immediate vesting, employer paid life insurance at twice your base annual salary, and employer paid short term and long term disability.

The salary range for this position is: $65,000 to $75,000 based upon experience.

What To Expect from The Interview Process

Hiring manager resume review

One way video interview on Sparkhire (we promise this isn’t scary! You have unlimited think time for ALL 4 questions we ask!) that will take 15 minutes.

30-minute phone interview with a member of the People and Culture team

Virtual On-Site Interview

The Enterprise Technology Team and the AMA

The Enterprise Technology team is a focused, dedicated, strategic group, who does whatever it takes to get the job done, keep the company’s technology up and running, while having fun along the way. Key departmental goals are continuing to build out and advance the AMA’s technology stack, both front office and back office. With a vision of advancing the mission, supporting our community and utilizing cutting edge technology and best practices to accomplish these themes. The Enterprise Technology’s departmental goals are both enablers and drivers of most of the organization's strategic initiatives, by unlocking and creating technology avenues and potential for business growth, strategic initiative activation, National/Local org alignment and creating operational efficiencies, via workflows, automation and data analytics.

At the American Marketing Association (AMA), we’re striving to be the most relevant voice shaping marketing around the world. Our passion and dedication to uncovering the next best practices in marketing, paired with our core values of being curious, courageous, grateful, joyful, customer-centric and stakeholder-sensitive, are the backbone of our motivated and energetic team. Together, we serve a community of more than 445,000 people who work, teach and study in the field of marketing.

For more information, visit the AMA’s new website, AMA.org, the foremost information resource on marketing.