Market America-Shop.com is seeking a SQL Database Developer.
The SQL database developer has expertise in SQL coding and data modeling, reporting and analytics, and has worked with Microsoft SQL server and Microsoft BI technologies. Designs and develops data processing, data models and reports to support our SHOP.COM site development team. Will also be responsible for organizing and improving workflow for our SSRS Report Server. The position will interact with Business users such as marketing, product managers, and managers of third party relationships.
Essential Duties and Responsibilities
Build an understanding of the business and how it maps to databases, then develop processes, reports or tools to extract the data needed.
Use MS SQL/SSIS/SSRS and Excel technologies to maintain and improve business reporting and analytics.
Data Warehouse Analysis, Design and Development. Development of new and maintenance of existing SSIS packages and process, SSRS/PowerBI/Tableau reports/dashboards and SSAS databases.
Development and maintenance of T-SQL Queries and stored procedures.
Work with other SQL developers to develop and extend data warehouse modeling to provide flexible and efficient access to information.
Lead project to consolidate BI servers, and improve report development/deployment workflow.
Work with business users and business analysts to identify information needs, and design effective reporting and information delivery.
Build, testing and deployment of MSBI components across multiple environments.
Performance tuning of T-SQL Queries, stored procedures, SSIS packages, SSRS reports and SSAS databases.
Management and monitoring of SSIS, SSRS, SSAS environments.
Development and implementation of process, procedures and SOPs for MSBI components.
Complies with company policies and procedures.
Performs other duties as needed.
Education and Experience
A bachelor's degree in science, technology, engineering, business or a similar field is required OR equivalent combination of education and experience.
7+ years of direct hands on Microsoft BI support including database , application design, administration and development of MSBI stack (SSIS, SSAS, SSRS).
Demonstrated SQL development experience working well with business users having varying levels of technical capability
Experience with querying large data sets and troubleshooting performance issues
Strong understanding of data warehousing and business intelligence architecture.
Understanding of Microsoft SQL Server database development and administration tasks
Strong understanding of ETL design and implementation.
Strong T-SQL development skills, including development of automation scripts.
Experience with Performance Tuning, including performance problem identification,
Excellent oral and written communication and collaboration skills required, to effectively work with a variety of business users and software developers.
Ability to act proactively and to apply creative problem-solving skills
Motivated learner with a passion for technology
Experience with Excel, Power BI, Tableau or another BI tools a plus
Experience with big data techniques a plus
Excellent organizational skills with attention to detail
Ability to meet deadlines, prioritize and multi-task effectively in a fast-paced work environment
Ability to work independently or as a member of a team to meet the stated objectives of Market America and marketamerica.com
Experience with development and documentation of technical specs, diagrams, and best practices.
Knowledge of cloud based (Azure and/or AWS) BI implementations.
Market America-Shop.com offers competitive salary and generous benefits, including health, dental, vision, life, short and long-term disability insurance, a 401(k) retirement plan with company match, and an on-site health clinic.
Qualified candidates should apply online. This position will be based in Monterey CA. Not a telecommuting position.
Market America is proud to be an equal opportunity employer.
Market America | SHOP.COM is changing the way people shop and changing the economic paradigm so anyone can become financially independent by creating their own economy and converting their spending into earning with the Shopping Annuity®.