Junior Bi Developer (Remote Opportunity)

Description
We’re actively seeking a Junior BI Developer to join the Enterprise Technology department in the Operations division!
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
• Contribute to the AMA Data Warehouse codebase and collaborate in the release management, documentation and maintenance thereof, including refactoring and query optimization.
• Collaborate in the implementation of developing models, productionizing code, and incorporating the results of such models into the BI environment.
• 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.
• Cleans and manages data, in addition to migrating and integrating data with various sources.
• Maintain and update existing dashboards and reports.

What You Have

• Excellent data analysis and data profiling skills.
• Expertise with integration technologies and processes
• 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
• Bachelor’s degree or equivalent work experience
• Proficiency in data quality development around address validation services, data profiling, cleansing, parsing, standardization, verification, matching and data quality exception monitoring and handling
• 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.

What You May Also Have

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

What You’ll Get

• A true ability to have an impact in delivering technology change in an ideal digital transformation period for the organization
• 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.
• Ability to attend professional development programs offered through the AMA
• Free American Marketing Association membership
• 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.
• 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
• 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
• Virtual On-Site Interview
• 30-minute phone interview with a member of the People and Culture team
• 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.

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