Use SQL Server Reporting Services (SSRS), as well as Tableau and Domo to create organized reports and beautiful dashboards
Analyze and process large amounts of quantitative data and provide actionable insights to the business
Design, develop, optimize, maintain and support ETL processes using data warehouse design best practices and SQL Server Integration Services (SSIS) to integrate data from multiple source systems into a Data Warehouse, cleansing data, transforming and loading data from multiple formats using SSIS and stored procedures
Modify databases according to requests and perform tests
Liaise with developers to improve applications and establish best practices
Solve database usage issues and malfunctions
Ensure all database programs meet company and performance requirements
Research and suggest new database products, services, and protocols to improve productivity, performance and enable deeper, more scalable solutions
Document procedures for all tools/processes you create
Work closely with Data Analysts, Data Developers, and business stakeholders on requirements and functional specifications to understand business priorities and translate requirements
Requirements:
Min 3 years of experience with SSRS
In-depth, hands-on experience with SQL
Knowledge of software development and user interface web applications
Proven experience with data warehousing, database design, and proficiency in DWH methodologies and best practices
Ability to understand front-end users’ requirements and a problem-solving attitude
Excellent communication skills, both verbal and written, in English to be able to work hand-in-hand and communicate with the team in the US
Bonus if you have:
SSIS as an ETL tool
Programming languages like C# or Python
Hadoop or Big data
Banking/finance industry
Data development process end-to-end
Business intelligence, big data, database tuning, application optimization, security, virtual computing and storage, incident tracking, and general database administration